<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="fs142834">user_mappings</title>
  <body>
    <p>The <codeph>user_mappings</codeph> view contains all of the user mappgins defined 
      in the current database. Greenplum Database displays only those user
       mappings to which the current user has access (by way of being the owner or having some privilege).</p>
    <table id="fs142842">
      <title>user_mappings</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="131pt"/>
        <colspec colnum="2" colname="col2" colwidth="73pt"/>
        <colspec colnum="3" colname="col3" colwidth="101pt"/>
        <colspec colnum="4" colname="col4" colwidth="145pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>authorization_identifier</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the user being mapped, or <codeph>PUBLIC</codeph> if
             the mapping is public.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_server_catalog</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the database in which the foreign server used by
              this mapping is defined (always the current database).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_server_name</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the foreign server used by this mapping.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
